Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 52413 |
| Missing cells | 69642 |
| Missing cells (%) | 8.3% |
| Duplicate rows | 1104 |
| Duplicate rows (%) | 2.1% |
| Total size in memory | 8.8 MiB |
| Average record size in memory | 176.3 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 2 |
14615_FERM0101.DO_2_PV has constant value "0.0" | Constant |
| Dataset has 1104 (2.1%) duplicate rows | Duplicates |
14615_FERM0101.PUMP_1_PV is highly imbalanced (99.9%) | Imbalance |
14615_FERM0101.Temperatura_PV has 4353 (8.3%) missing values | Missing |
14615_FERM0101.Single_Use_pH_PV has 4353 (8.3%) missing values | Missing |
14615_FERM0101.Single_Use_DO_PV has 4353 (8.3%) missing values | Missing |
14615_FERM0101.PUMP_2_TOTAL has 4352 (8.3%) missing values | Missing |
14615_FERM0101.PUMP_2_PV has 4353 (8.3%) missing values | Missing |
14615_FERM0101.PUMP_1_TOTAL has 4352 (8.3%) missing values | Missing |
14615_FERM0101.PUMP_1_PV has 4353 (8.3%) missing values | Missing |
14615_FERM0101.pH_2_PV has 4352 (8.3%) missing values | Missing |
14615_FERM0101.pH_1_PV has 4352 (8.3%) missing values | Missing |
14615_FERM0101.Load_Cell_Net_PV has 4352 (8.3%) missing values | Missing |
14615_FERM0101.Gas_Overlay_PV has 4353 (8.3%) missing values | Missing |
14615_FERM0101.DO_2_PV has 4353 (8.3%) missing values | Missing |
14615_FERM0101.DO_1_PV has 4353 (8.3%) missing values | Missing |
14615_FERM0101.Biocontainer_Pressure_PV has 4352 (8.3%) missing values | Missing |
14615_FERM0101.Air_Sparge_PV has 4353 (8.3%) missing values | Missing |
14615_FERM0101.Agitation_PV has 4353 (8.3%) missing values | Missing |
14615_FERM0101.PUMP_2_TOTAL has 13306 (25.4%) zeros | Zeros |
14615_FERM0101.PUMP_2_PV has 41516 (79.2%) zeros | Zeros |
14615_FERM0101.PUMP_1_TOTAL has 3816 (7.3%) zeros | Zeros |
14615_FERM0101.Load_Cell_Net_PV has 1541 (2.9%) zeros | Zeros |
14615_FERM0101.Gas_Overlay_PV has 16476 (31.4%) zeros | Zeros |
14615_FERM0101.DO_1_PV has 36033 (68.7%) zeros | Zeros |
14615_FERM0101.Air_Sparge_PV has 44083 (84.1%) zeros | Zeros |
14615_FERM0101.Agitation_PV has 25124 (47.9%) zeros | Zeros |
Reproduction
| Analysis started | 2024-09-29 18:19:29.483670 |
|---|---|
| Analysis finished | 2024-09-29 18:19:44.500343 |
| Duration | 15.02 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
14615_FERM0101.Temperatura_PV
Real number (ℝ)
MISSING
| Distinct | 24033 |
|---|---|
| Distinct (%) | 50.0% |
| Missing | 4353 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.022394 |
| Minimum | 2.8799988 |
|---|---|
| Maximum | 31.22899 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 2.8799988 |
|---|---|
| 5-th percentile | 4.6246869 |
| Q1 | 14.935999 |
| median | 17.176927 |
| Q3 | 28.551722 |
| 95-th percentile | 29.631995 |
| Maximum | 31.22899 |
| Range | 28.348991 |
| Interquartile range (IQR) | 13.615724 |
Descriptive statistics
| Standard deviation | 7.6664354 |
|---|---|
| Coefficient of variation (CV) | 0.40302159 |
| Kurtosis | -0.80942924 |
| Mean | 19.022394 |
| Median Absolute Deviation (MAD) | 5.2489456 |
| Skewness | -0.020907413 |
| Sum | 914216.25 |
| Variance | 58.774232 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 29.60799561 | 1552 | 3.0% |
| 29.59200439 | 1548 | 3.0% |
| 29.63199463 | 1057 | 2.0% |
| 29.56800537 | 1038 | 2.0% |
| 29.55999756 | 517 | 1.0% |
| 29.64000244 | 507 | 1.0% |
| 3.191998291 | 362 | 0.7% |
| 3.208001709 | 327 | 0.6% |
| 17.67199707 | 249 | 0.5% |
| 29.55200195 | 241 | 0.5% |
| Other values (24023) | 40662 | |
| (Missing) | 4353 | 8.3% |
| Value | Count | Frequency (%) |
| 2.879998779 | 1 | < 0.1% |
| 3.032000732 | 1 | < 0.1% |
| 3.088000488 | 1 | < 0.1% |
| 3.096002197 | 1 | < 0.1% |
| 3.111999512 | 2 | < 0.1% |
| 3.12800293 | 5 | |
| 3.128008392 | 1 | < 0.1% |
| 3.128163024 | 1 | < 0.1% |
| 3.12816351 | 1 | < 0.1% |
| 3.128260176 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 31.22898975 | 1 | < 0.1% |
| 31.2270481 | 1 | < 0.1% |
| 31.21600342 | 3 | |
| 31.2087176 | 1 | < 0.1% |
| 31.2 | 3 | |
| 31.19630081 | 1 | < 0.1% |
| 31.19200439 | 2 | |
| 31.16800537 | 2 | |
| 31.16043226 | 1 | < 0.1% |
| 31.13274982 | 1 | < 0.1% |
14615_FERM0101.Single_Use_pH_PV
Real number (ℝ)
MISSING
| Distinct | 2486 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 4353 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 596.47506 |
| Minimum | -794.33599 |
|---|---|
| Maximum | 805.696 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 40 |
| Negative (%) | 0.1% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -794.33599 |
|---|---|
| 5-th percentile | 5.7200001 |
| Q1 | 5.984 |
| median | 799.88799 |
| Q3 | 799.93599 |
| 95-th percentile | 800.06401 |
| Maximum | 805.696 |
| Range | 1600.032 |
| Interquartile range (IQR) | 793.95199 |
Descriptive statistics
| Standard deviation | 346.86955 |
|---|---|
| Coefficient of variation (CV) | 0.58153237 |
| Kurtosis | -0.74471465 |
| Mean | 596.47506 |
| Median Absolute Deviation (MAD) | 0.095996094 |
| Skewness | -1.1183187 |
| Sum | 28666591 |
| Variance | 120318.49 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 799.9199707 | 4669 | 8.9% |
| 799.7919922 | 3854 | 7.4% |
| 799.8959961 | 3390 | 6.5% |
| 799.9040039 | 2359 | 4.5% |
| 799.9439941 | 1929 | 3.7% |
| 799.8640137 | 1877 | 3.6% |
| 799.952002 | 1611 | 3.1% |
| 799.8799805 | 1506 | 2.9% |
| 799.9120117 | 1322 | 2.5% |
| 800.0560059 | 1317 | 2.5% |
| Other values (2476) | 24226 | |
| (Missing) | 4353 | 8.3% |
| Value | Count | Frequency (%) |
| -794.3359863 | 1 | < 0.1% |
| -788.3519531 | 1 | < 0.1% |
| -0.2719997406 | 1 | < 0.1% |
| -0.263999939 | 1 | < 0.1% |
| -0.2240001678 | 1 | < 0.1% |
| -0.2 | 5 | |
| -0.1759998322 | 1 | < 0.1% |
| -0.1680000305 | 1 | < 0.1% |
| -0.1279998779 | 2 | < 0.1% |
| -0.1119998932 | 3 |
| Value | Count | Frequency (%) |
| 805.6959961 | 455 | 0.9% |
| 802.4080078 | 537 | |
| 801.752002 | 109 | 0.2% |
| 800.1199707 | 786 | |
| 800.0640137 | 1216 | |
| 800.0560059 | 1317 | |
| 800.0239746 | 1007 | |
| 800.0080078 | 1126 | |
| 799.9919922 | 456 | 0.9% |
| 799.9759766 | 461 | 0.9% |
14615_FERM0101.Single_Use_DO_PV
Real number (ℝ)
MISSING
| Distinct | 10905 |
|---|---|
| Distinct (%) | 22.7% |
| Missing | 4353 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 577.74084 |
| Minimum | 0 |
|---|---|
| Maximum | 815.40313 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 14.717587 |
| Q1 | 640.96787 |
| median | 721.62363 |
| Q3 | 799.99199 |
| 95-th percentile | 799.99199 |
| Maximum | 815.40313 |
| Range | 815.40313 |
| Interquartile range (IQR) | 159.02412 |
Descriptive statistics
| Standard deviation | 314.92143 |
|---|---|
| Coefficient of variation (CV) | 0.54509116 |
| Kurtosis | -0.62833474 |
| Mean | 577.74084 |
| Median Absolute Deviation (MAD) | 78.368359 |
| Skewness | -1.1154595 |
| Sum | 27766225 |
| Variance | 99175.504 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 799.9919922 | 20256 | |
| 659.7328125 | 3794 | 7.2% |
| 753.855957 | 2179 | 4.2% |
| 693.7148926 | 1279 | 2.4% |
| 640.9678711 | 1248 | 2.4% |
| 716.7102539 | 1235 | 2.4% |
| 695.1012207 | 888 | 1.7% |
| 667.8287109 | 753 | 1.4% |
| 768.0414551 | 582 | 1.1% |
| 82.97983398 | 412 | 0.8% |
| Other values (10895) | 15434 | |
| (Missing) | 4353 | 8.3% |
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 1.211847604 | 1 | < 0.1% |
| 1.233964179 | 1 | < 0.1% |
| 1.244670814 | 1 | < 0.1% |
| 1.295096852 | 1 | < 0.1% |
| 1.300275692 | 1 | < 0.1% |
| 1.313364029 | 1 | < 0.1% |
| 1.361724446 | 1 | < 0.1% |
| 1.431655166 | 1 | < 0.1% |
| 1.433451477 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 815.403125 | 189 | 0.4% |
| 812.6696289 | 138 | 0.3% |
| 799.9919922 | 20256 | |
| 799.8291548 | 1 | < 0.1% |
| 799.391338 | 1 | < 0.1% |
| 799.278426 | 1 | < 0.1% |
| 799.077949 | 1 | < 0.1% |
| 787.4319824 | 1 | < 0.1% |
| 777.5439941 | 1 | < 0.1% |
| 775.8 | 1 | < 0.1% |
14615_FERM0101.PUMP_2_TOTAL
Real number (ℝ)
MISSING ZEROS
| Distinct | 8950 |
|---|---|
| Distinct (%) | 18.6% |
| Missing | 4352 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3647.9799 |
| Minimum | 0 |
|---|---|
| Maximum | 12268.625 |
| Zeros | 13306 |
| Zeros (%) | 25.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2081.443 |
| Q3 | 6996.8898 |
| 95-th percentile | 9120.9797 |
| Maximum | 12268.625 |
| Range | 12268.625 |
| Interquartile range (IQR) | 6996.8898 |
Descriptive statistics
| Standard deviation | 3586.8652 |
|---|---|
| Coefficient of variation (CV) | 0.98324696 |
| Kurtosis | -1.6295878 |
| Mean | 3647.9799 |
| Median Absolute Deviation (MAD) | 2081.443 |
| Skewness | 0.26817547 |
| Sum | 1.7532556 × 108 |
| Variance | 12865602 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 13306 | |
| 9120.979687 | 3790 | 7.2% |
| 6505.707813 | 2181 | 4.2% |
| 5668.085156 | 1629 | 3.1% |
| 248.8854736 | 1337 | 2.6% |
| 7370.183594 | 1328 | 2.5% |
| 6996.889844 | 1285 | 2.5% |
| 167.4596191 | 1049 | 2.0% |
| 7987.819531 | 1033 | 2.0% |
| 7659.826563 | 785 | 1.5% |
| Other values (8940) | 20338 | |
| (Missing) | 4352 | 8.3% |
| Value | Count | Frequency (%) |
| 0 | 13306 | |
| 0.1468597095 | 1 | < 0.1% |
| 1.455256405 | 1 | < 0.1% |
| 2.400578172 | 1 | < 0.1% |
| 2.80128212 | 2 | < 0.1% |
| 4.28546524 | 1 | < 0.1% |
| 5.441709137 | 3 | < 0.1% |
| 7.129507257 | 1 | < 0.1% |
| 7.677305295 | 1 | < 0.1% |
| 9.401261139 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 12268.625 | 41 | |
| 12235.15078 | 1 | < 0.1% |
| 12200.79766 | 1 | < 0.1% |
| 12138.02578 | 1 | < 0.1% |
| 12083.57969 | 1 | < 0.1% |
| 12013.67734 | 32 | |
| 12013.36273 | 1 | < 0.1% |
| 12002.17031 | 2 | < 0.1% |
| 11992.73203 | 1 | < 0.1% |
| 11976.50078 | 1 | < 0.1% |
14615_FERM0101.PUMP_2_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 5904 |
|---|---|
| Distinct (%) | 12.3% |
| Missing | 4353 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5182882 |
| Minimum | 0 |
|---|---|
| Maximum | 48 |
| Zeros | 41516 |
| Zeros (%) | 79.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 4.9968242 |
| Maximum | 48 |
| Range | 48 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.6944726 |
|---|---|
| Coefficient of variation (CV) | 3.2693636 |
| Kurtosis | 35.767311 |
| Mean | 0.5182882 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.2042309 |
| Sum | 24908.931 |
| Variance | 2.8712372 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 41516 | |
| 8 | 585 | 1.1% |
| 7.610464478 | 13 | < 0.1% |
| 7.200439453 | 11 | < 0.1% |
| 2.400146484 | 8 | < 0.1% |
| 4.800292969 | 5 | < 0.1% |
| 0.2255298615 | 3 | < 0.1% |
| 0.003704071045 | 3 | < 0.1% |
| 48 | 2 | < 0.1% |
| 0.4395198822 | 2 | < 0.1% |
| Other values (5894) | 5912 | 11.3% |
| (Missing) | 4353 | 8.3% |
| Value | Count | Frequency (%) |
| 0 | 41516 | |
| 5.020227855 × 10-6 | 1 | < 0.1% |
| 5.724162096 × 10-6 | 1 | < 0.1% |
| 1.594937473 × 10-5 | 1 | < 0.1% |
| 2.942391561 × 10-5 | 1 | < 0.1% |
| 4.492293769 × 10-5 | 1 | < 0.1% |
| 5.350303202 × 10-5 | 1 | < 0.1% |
| 0.0001122938038 | 1 | < 0.1% |
| 0.0002339555154 | 1 | < 0.1% |
| 0.0003401865835 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 48 | 2 | < 0.1% |
| 8 | 585 | |
| 7.999999282 | 1 | < 0.1% |
| 7.999982142 | 1 | < 0.1% |
| 7.999976459 | 1 | < 0.1% |
| 7.999970573 | 1 | < 0.1% |
| 7.999955503 | 1 | < 0.1% |
| 7.999946716 | 1 | < 0.1% |
| 7.999940426 | 1 | < 0.1% |
| 7.999930213 | 1 | < 0.1% |
14615_FERM0101.PUMP_1_TOTAL
Real number (ℝ)
MISSING ZEROS
| Distinct | 158 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 4352 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.139296 |
| Minimum | 0 |
|---|---|
| Maximum | 157.07986 |
| Zeros | 3816 |
| Zeros (%) | 7.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 9.2399994 |
| median | 21.119997 |
| Q3 | 31.680002 |
| 95-th percentile | 60.720026 |
| Maximum | 157.07986 |
| Range | 157.07986 |
| Interquartile range (IQR) | 22.440002 |
Descriptive statistics
| Standard deviation | 20.485735 |
|---|---|
| Coefficient of variation (CV) | 0.84864678 |
| Kurtosis | 3.0490869 |
| Mean | 24.139296 |
| Median Absolute Deviation (MAD) | 11.879997 |
| Skewness | 1.5858555 |
| Sum | 1160158.7 |
| Variance | 419.66536 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3816 | 7.3% |
| 40.47999878 | 3812 | 7.3% |
| 21.11999664 | 3547 | 6.8% |
| 6.6 | 3498 | 6.7% |
| 22.43999634 | 2441 | 4.7% |
| 17.15999756 | 2083 | 4.0% |
| 11.87999878 | 1999 | 3.8% |
| 5.279999924 | 1912 | 3.6% |
| 26.39999695 | 1864 | 3.6% |
| 28.16000366 | 1375 | 2.6% |
| Other values (148) | 21714 | |
| (Missing) | 4352 | 8.3% |
| Value | Count | Frequency (%) |
| 0 | 3816 | |
| 0.01962204832 | 1 | < 0.1% |
| 0.07128547617 | 1 | < 0.1% |
| 0.1315726093 | 1 | < 0.1% |
| 0.1423443709 | 1 | < 0.1% |
| 0.1841951646 | 1 | < 0.1% |
| 0.2217831827 | 1 | < 0.1% |
| 0.3634535565 | 1 | < 0.1% |
| 0.3980566611 | 1 | < 0.1% |
| 1.310444561 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 157.0798584 | 1 | < 0.1% |
| 100.7599487 | 211 | 0.4% |
| 97.68005981 | 410 | |
| 96.79995117 | 745 | |
| 88.44005127 | 17 | < 0.1% |
| 81.84004517 | 42 | 0.1% |
| 81.39996948 | 17 | < 0.1% |
| 80.95997314 | 93 | 0.2% |
| 79.63997803 | 80 | 0.2% |
| 77.8800415 | 19 | < 0.1% |
14615_FERM0101.PUMP_1_PV
Categorical
IMBALANCE MISSING
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4353 |
| Missing (%) | 8.3% |
| Memory size | 2.8 MiB |
| 0.0 | |
|---|---|
| 48.0 | 2 |
| 50.0624194986624 | 1 |
Length
| Max length | 16 |
|---|---|
| Median length | 3 |
| Mean length | 3.0003121 |
| Min length | 3 |
Characters and Unicode
| Total characters | 144195 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 48057 | |
| 48.0 | 2 | < 0.1% |
| 50.0624194986624 | 1 | < 0.1% |
| (Missing) | 4353 | 8.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 48057 | |
| 48.0 | 2 | < 0.1% |
| 50.0624194986624 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 96118 | |
| . | 48060 | |
| 4 | 5 | < 0.1% |
| 8 | 3 | < 0.1% |
| 6 | 3 | < 0.1% |
| 2 | 2 | < 0.1% |
| 9 | 2 | < 0.1% |
| 5 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 144195 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 96118 | |
| . | 48060 | |
| 4 | 5 | < 0.1% |
| 8 | 3 | < 0.1% |
| 6 | 3 | < 0.1% |
| 2 | 2 | < 0.1% |
| 9 | 2 | < 0.1% |
| 5 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 144195 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 96118 | |
| . | 48060 | |
| 4 | 5 | < 0.1% |
| 8 | 3 | < 0.1% |
| 6 | 3 | < 0.1% |
| 2 | 2 | < 0.1% |
| 9 | 2 | < 0.1% |
| 5 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 144195 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 96118 | |
| . | 48060 | |
| 4 | 5 | < 0.1% |
| 8 | 3 | < 0.1% |
| 6 | 3 | < 0.1% |
| 2 | 2 | < 0.1% |
| 9 | 2 | < 0.1% |
| 5 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
14615_FERM0101.pH_2_PV
Real number (ℝ)
MISSING
| Distinct | 3475 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 4352 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0131957 |
| Minimum | -0.26444588 |
|---|---|
| Maximum | 105.31427 |
| Zeros | 25 |
| Zeros (%) | < 0.1% |
| Negative | 19973 |
| Negative (%) | 38.1% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -0.26444588 |
|---|---|
| 5-th percentile | -0.23476257 |
| Q1 | -0.23476257 |
| median | 1.5329995 |
| Q3 | 5.5634209 |
| 95-th percentile | 5.8844936 |
| Maximum | 105.31427 |
| Range | 105.57872 |
| Interquartile range (IQR) | 5.7981834 |
Descriptive statistics
| Standard deviation | 3.0103852 |
|---|---|
| Coefficient of variation (CV) | 1.4953267 |
| Kurtosis | 296.54175 |
| Mean | 2.0131957 |
| Median Absolute Deviation (MAD) | 1.7677621 |
| Skewness | 10.334694 |
| Sum | 96756.198 |
| Variance | 9.0624192 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -0.2347625732 | 18573 | |
| 1.564368343 | 2487 | 4.7% |
| 1.676117706 | 2170 | 4.1% |
| -0.2644458771 | 1356 | 2.6% |
| 1.592201424 | 1263 | 2.4% |
| 1.401505852 | 1036 | 2.0% |
| 1.637450981 | 856 | 1.6% |
| 1.578890514 | 557 | 1.1% |
| 1.675854492 | 555 | 1.1% |
| 1.641864586 | 465 | 0.9% |
| Other values (3465) | 18743 | |
| (Missing) | 4352 | 8.3% |
| Value | Count | Frequency (%) |
| -0.2644458771 | 1356 | 2.6% |
| -0.2347625732 | 18573 | |
| -0.2346772473 | 1 | < 0.1% |
| -0.2344145706 | 1 | < 0.1% |
| -0.2331716799 | 1 | < 0.1% |
| -0.2330111366 | 1 | < 0.1% |
| -0.2322276584 | 1 | < 0.1% |
| -0.2315282666 | 1 | < 0.1% |
| -0.2297079138 | 1 | < 0.1% |
| -0.2108184814 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 105.31427 | 1 | < 0.1% |
| 93.08724365 | 1 | < 0.1% |
| 91.88721924 | 1 | < 0.1% |
| 91.58453369 | 1 | < 0.1% |
| 91.29263916 | 2 | |
| 90.9899292 | 3 | |
| 90.68723145 | 4 | |
| 90.39533691 | 4 | |
| 90.09262695 | 1 | < 0.1% |
| 8.700935857 | 1 | < 0.1% |
14615_FERM0101.pH_1_PV
Real number (ℝ)
MISSING
| Distinct | 4182 |
|---|---|
| Distinct (%) | 8.7% |
| Missing | 4352 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.557953 |
| Minimum | 0 |
|---|---|
| Maximum | 38.096255 |
| Zeros | 36 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.3002729 |
| Q1 | 1.3002729 |
| median | 1.4162539 |
| Q3 | 4.1155235 |
| 95-th percentile | 5.8862934 |
| Maximum | 38.096255 |
| Range | 38.096255 |
| Interquartile range (IQR) | 2.8152506 |
Descriptive statistics
| Standard deviation | 1.8316659 |
|---|---|
| Coefficient of variation (CV) | 0.71606705 |
| Kurtosis | 2.3185348 |
| Mean | 2.557953 |
| Median Absolute Deviation (MAD) | 0.11598101 |
| Skewness | 1.1834102 |
| Sum | 122937.78 |
| Variance | 3.3549998 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.300272942 | 22903 | |
| 4.115523529 | 5057 | 9.6% |
| 1.658554077 | 1217 | 2.3% |
| 1.416253948 | 1196 | 2.3% |
| 1.544090271 | 696 | 1.3% |
| 1.497356987 | 680 | 1.3% |
| 1.61123867 | 602 | 1.1% |
| 1.49628067 | 459 | 0.9% |
| 1.54283371 | 456 | 0.9% |
| 1.667505264 | 390 | 0.7% |
| Other values (4172) | 14405 | |
| (Missing) | 4352 | 8.3% |
| Value | Count | Frequency (%) |
| 0 | 36 | |
| 0.0009447473402 | 1 | < 0.1% |
| 0.002654317213 | 1 | < 0.1% |
| 0.003621569916 | 1 | < 0.1% |
| 0.005281124416 | 1 | < 0.1% |
| 0.007431849441 | 1 | < 0.1% |
| 0.00992509168 | 1 | < 0.1% |
| 0.01048191482 | 1 | < 0.1% |
| 0.01232262364 | 1 | < 0.1% |
| 0.01280210581 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 38.09625549 | 1 | |
| 7.595863342 | 1 | |
| 7.586955261 | 1 | |
| 7.583180324 | 1 | |
| 7.578674523 | 1 | |
| 7.578654555 | 1 | |
| 7.578651428 | 2 | |
| 7.570815323 | 1 | |
| 7.570722985 | 1 | |
| 7.570643616 | 1 |
14615_FERM0101.Load_Cell_Net_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 1990 |
|---|---|
| Distinct (%) | 4.1% |
| Missing | 4352 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 741.58854 |
| Minimum | -22.4 |
|---|---|
| Maximum | 1711.4491 |
| Zeros | 1541 |
| Zeros (%) | 2.9% |
| Negative | 19766 |
| Negative (%) | 37.7% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -22.4 |
|---|---|
| 5-th percentile | -18.4 |
| Q1 | -16.4 |
| median | 2.8 |
| Q3 | 1592 |
| 95-th percentile | 1662.8 |
| Maximum | 1711.4491 |
| Range | 1733.8491 |
| Interquartile range (IQR) | 1608.4 |
Descriptive statistics
| Standard deviation | 800.29719 |
|---|---|
| Coefficient of variation (CV) | 1.0791661 |
| Kurtosis | -1.9533211 |
| Mean | 741.58854 |
| Median Absolute Deviation (MAD) | 21.6 |
| Skewness | 0.15313062 |
| Sum | 35641487 |
| Variance | 640475.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -18 | 2867 | 5.5% |
| -18.4 | 2528 | 4.8% |
| -14.4 | 2126 | 4.1% |
| -17.2 | 2017 | 3.8% |
| -17.6 | 1763 | 3.4% |
| -18.8 | 1542 | 2.9% |
| 0 | 1541 | 2.9% |
| -0.4 | 1302 | 2.5% |
| -1.6 | 1247 | 2.4% |
| 2 | 762 | 1.5% |
| Other values (1980) | 30366 | |
| (Missing) | 4352 | 8.3% |
| Value | Count | Frequency (%) |
| -22.4 | 2 | < 0.1% |
| -22 | 3 | < 0.1% |
| -21.6 | 4 | < 0.1% |
| -21.2 | 10 | < 0.1% |
| -20.8 | 16 | < 0.1% |
| -20.4 | 23 | < 0.1% |
| -20 | 28 | 0.1% |
| -19.68075124 | 1 | < 0.1% |
| -19.6 | 47 | 0.1% |
| -19.2 | 611 |
| Value | Count | Frequency (%) |
| 1711.449056 | 1 | < 0.1% |
| 1710.587867 | 1 | < 0.1% |
| 1706.719481 | 1 | < 0.1% |
| 1706 | 17 | |
| 1705.6 | 25 | |
| 1705.591693 | 1 | < 0.1% |
| 1705.505852 | 1 | < 0.1% |
| 1705.457903 | 1 | < 0.1% |
| 1705.2 | 31 | |
| 1705.058271 | 1 | < 0.1% |
14615_FERM0101.Gas_Overlay_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 31585 |
|---|---|
| Distinct (%) | 65.7% |
| Missing | 4353 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7712883 |
| Minimum | 0 |
|---|---|
| Maximum | 16.001782 |
| Zeros | 16476 |
| Zeros (%) | 31.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3.9997998 |
| Q3 | 4.0001441 |
| 95-th percentile | 4.0008662 |
| Maximum | 16.001782 |
| Range | 16.001782 |
| Interquartile range (IQR) | 4.0001441 |
Descriptive statistics
| Standard deviation | 2.1392589 |
|---|---|
| Coefficient of variation (CV) | 0.77193658 |
| Kurtosis | -0.27687384 |
| Mean | 2.7712883 |
| Median Absolute Deviation (MAD) | 0.00053469789 |
| Skewness | -0.046576707 |
| Sum | 133188.12 |
| Variance | 4.5764284 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 16476 | |
| 3.999874464 | 1 | < 0.1% |
| 4.000053718 | 1 | < 0.1% |
| 3.999962357 | 1 | < 0.1% |
| 4.000154254 | 1 | < 0.1% |
| 4.000174089 | 1 | < 0.1% |
| 4.000222955 | 1 | < 0.1% |
| 4.000418269 | 1 | < 0.1% |
| 4.000196392 | 1 | < 0.1% |
| 3.994040144 | 1 | < 0.1% |
| Other values (31575) | 31575 | |
| (Missing) | 4353 | 8.3% |
| Value | Count | Frequency (%) |
| 0 | 16476 | |
| 3.95767525 | 1 | < 0.1% |
| 3.959049178 | 1 | < 0.1% |
| 3.962996066 | 1 | < 0.1% |
| 3.963635189 | 1 | < 0.1% |
| 3.963674017 | 1 | < 0.1% |
| 3.975593718 | 1 | < 0.1% |
| 3.977468455 | 1 | < 0.1% |
| 3.977937658 | 1 | < 0.1% |
| 3.978744818 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 16.00178203 | 1 | |
| 16.00161624 | 1 | |
| 16.00104979 | 1 | |
| 16.00076107 | 1 | |
| 16.00057974 | 1 | |
| 16.00036089 | 1 | |
| 16.00022746 | 1 | |
| 16.00009975 | 1 | |
| 15.99966771 | 1 | |
| 15.99964889 | 1 |
14615_FERM0101.DO_2_PV
Categorical
CONSTANT MISSING
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4353 |
| Missing (%) | 8.3% |
| Memory size | 2.8 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 144180 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 48060 | |
| (Missing) | 4353 | 8.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 48060 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 96120 | |
| . | 48060 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 144180 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 96120 | |
| . | 48060 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 144180 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 96120 | |
| . | 48060 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 144180 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 96120 | |
| . | 48060 |
14615_FERM0101.DO_1_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 7654 |
|---|---|
| Distinct (%) | 15.9% |
| Missing | 4353 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.8138307 |
| Minimum | 0 |
|---|---|
| Maximum | 109.58795 |
| Zeros | 36033 |
| Zeros (%) | 68.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3.2842045 |
| 95-th percentile | 25.302866 |
| Maximum | 109.58795 |
| Range | 109.58795 |
| Interquartile range (IQR) | 3.2842045 |
Descriptive statistics
| Standard deviation | 12.754246 |
|---|---|
| Coefficient of variation (CV) | 2.1937767 |
| Kurtosis | 12.224773 |
| Mean | 5.8138307 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.1709245 |
| Sum | 279412.7 |
| Variance | 162.6708 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 36033 | |
| 12.15542221 | 30 | 0.1% |
| 24.23786316 | 29 | 0.1% |
| 23.30582581 | 24 | < 0.1% |
| 23.0339798 | 24 | < 0.1% |
| 24.37378693 | 21 | < 0.1% |
| 12.0136528 | 21 | < 0.1% |
| 12.30244141 | 20 | < 0.1% |
| 23.66294556 | 20 | < 0.1% |
| 22.63106689 | 19 | < 0.1% |
| Other values (7644) | 11819 | 22.5% |
| (Missing) | 4353 | 8.3% |
| Value | Count | Frequency (%) |
| 0 | 36033 | |
| 1.149908161 | 1 | < 0.1% |
| 1.296928406 | 1 | < 0.1% |
| 1.43869791 | 1 | < 0.1% |
| 1.577126503 | 1 | < 0.1% |
| 1.869573784 | 1 | < 0.1% |
| 2.168548203 | 1 | < 0.1% |
| 2.665699005 | 1 | < 0.1% |
| 2.936757851 | 1 | < 0.1% |
| 3.198258209 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 109.5879517 | 1 | |
| 92.80671387 | 1 | |
| 88.48379517 | 1 | |
| 88.13513545 | 1 | |
| 87.91049194 | 1 | |
| 86.59971924 | 1 | |
| 84.47548828 | 1 | |
| 84.0079895 | 1 | |
| 83.82406616 | 1 | |
| 83.66962891 | 1 |
14615_FERM0101.Biocontainer_Pressure_PV
Real number (ℝ)
MISSING
| Distinct | 22265 |
|---|---|
| Distinct (%) | 46.3% |
| Missing | 4352 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 148.23927 |
| Minimum | -14.840857 |
|---|---|
| Maximum | 480 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 19534 |
| Negative (%) | 37.3% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -14.840857 |
|---|---|
| 5-th percentile | -1.6348389 |
| Q1 | -0.42372254 |
| median | 0.37129787 |
| Q3 | 480 |
| 95-th percentile | 480 |
| Maximum | 480 |
| Range | 494.84086 |
| Interquartile range (IQR) | 480.42372 |
Descriptive statistics
| Standard deviation | 221.86287 |
|---|---|
| Coefficient of variation (CV) | 1.4966538 |
| Kurtosis | -1.3166685 |
| Mean | 148.23927 |
| Median Absolute Deviation (MAD) | 1.1738437 |
| Skewness | 0.82653836 |
| Sum | 7124527.7 |
| Variance | 49223.133 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 480 | 14851 | |
| -0.2372680664 | 443 | 0.8% |
| -0.2170166016 | 349 | 0.7% |
| -0.2575256348 | 316 | 0.6% |
| -0.01446533203 | 304 | 0.6% |
| 0.005786132813 | 291 | 0.6% |
| 0.2083312988 | 285 | 0.5% |
| -0.4600708008 | 283 | 0.5% |
| -0.4803222656 | 259 | 0.5% |
| -0.6626159668 | 251 | 0.5% |
| Other values (22255) | 30429 | |
| (Missing) | 4352 | 8.3% |
| Value | Count | Frequency (%) |
| -14.84085693 | 1 | |
| -10.546875 | 1 | |
| -10.46581812 | 1 | |
| -10.46541518 | 1 | |
| -10.40535583 | 1 | |
| -10.38617345 | 1 | |
| -10.38502773 | 1 | |
| -10.22196953 | 1 | |
| -10.20229146 | 1 | |
| -10.18298932 | 1 |
| Value | Count | Frequency (%) |
| 480 | 14851 | |
| 170.8269393 | 1 | < 0.1% |
| 19.67327912 | 1 | < 0.1% |
| 19.025627 | 1 | < 0.1% |
| 18.43674328 | 1 | < 0.1% |
| 17.7083313 | 1 | < 0.1% |
| 17.44502563 | 1 | < 0.1% |
| 17.08036093 | 1 | < 0.1% |
| 16.56163216 | 1 | < 0.1% |
| 16.00449437 | 1 | < 0.1% |
14615_FERM0101.Air_Sparge_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 3977 |
|---|---|
| Distinct (%) | 8.3% |
| Missing | 4353 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.2027467 |
| Minimum | 0 |
|---|---|
| Maximum | 160.27601 |
| Zeros | 44083 |
| Zeros (%) | 84.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 29.3048 |
| Maximum | 160.27601 |
| Range | 160.27601 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 12.943404 |
|---|---|
| Coefficient of variation (CV) | 4.041345 |
| Kurtosis | 19.628648 |
| Mean | 3.2027467 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.3456334 |
| Sum | 153924 |
| Variance | 167.53171 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 44083 | |
| 62.88121338 | 2 | < 0.1% |
| 64.01446627 | 1 | < 0.1% |
| 64.34274699 | 1 | < 0.1% |
| 64.0326881 | 1 | < 0.1% |
| 63.99061313 | 1 | < 0.1% |
| 63.99311586 | 1 | < 0.1% |
| 63.9980221 | 1 | < 0.1% |
| 63.96494077 | 1 | < 0.1% |
| 64.00094422 | 1 | < 0.1% |
| Other values (3967) | 3967 | 7.6% |
| (Missing) | 4353 | 8.3% |
| Value | Count | Frequency (%) |
| 0 | 44083 | |
| 0.002813267495 | 1 | < 0.1% |
| 0.002902076209 | 1 | < 0.1% |
| 0.007252627722 | 1 | < 0.1% |
| 0.01454566361 | 1 | < 0.1% |
| 0.02311518132 | 1 | < 0.1% |
| 0.02662493759 | 1 | < 0.1% |
| 0.03108584517 | 1 | < 0.1% |
| 0.07191738577 | 1 | < 0.1% |
| 0.07565658565 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 160.2760132 | 1 | |
| 160.2630737 | 1 | |
| 160.1191105 | 1 | |
| 160.1169987 | 1 | |
| 160.1064904 | 1 | |
| 160.062027 | 1 | |
| 160.0504738 | 1 | |
| 160.0120159 | 1 | |
| 159.9871997 | 1 | |
| 159.9833286 | 1 |
14615_FERM0101.Agitation_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 786 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 4353 |
| Missing (%) | 8.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.496487 |
| Minimum | 0 |
|---|---|
| Maximum | 80 |
| Zeros | 25124 |
| Zeros (%) | 47.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 80 |
| 95-th percentile | 80 |
| Maximum | 80 |
| Range | 80 |
| Interquartile range (IQR) | 80 |
Descriptive statistics
| Standard deviation | 35.796978 |
|---|---|
| Coefficient of variation (CV) | 1.2136014 |
| Kurtosis | -1.5016824 |
| Mean | 29.496487 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.5986237 |
| Sum | 1417601.2 |
| Variance | 1281.4236 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 25124 | |
| 80 | 15079 | |
| 20 | 5433 | 10.4% |
| 36 | 1066 | 2.0% |
| 44 | 524 | 1.0% |
| 40 | 29 | 0.1% |
| 72 | 15 | < 0.1% |
| 28 | 5 | < 0.1% |
| 32 | 3 | < 0.1% |
| 48 | 3 | < 0.1% |
| Other values (776) | 779 | 1.5% |
| (Missing) | 4353 | 8.3% |
| Value | Count | Frequency (%) |
| 0 | 25124 | |
| 16.90591273 | 1 | < 0.1% |
| 20 | 5433 | 10.4% |
| 20.04541852 | 1 | < 0.1% |
| 20.0564596 | 1 | < 0.1% |
| 20.11278775 | 1 | < 0.1% |
| 20.20262012 | 1 | < 0.1% |
| 20.28988183 | 1 | < 0.1% |
| 20.31330564 | 1 | < 0.1% |
| 20.52029305 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 80 | 15079 | |
| 79.90183953 | 1 | < 0.1% |
| 79.85973765 | 1 | < 0.1% |
| 79.82890535 | 1 | < 0.1% |
| 79.75873759 | 1 | < 0.1% |
| 79.75764121 | 1 | < 0.1% |
| 79.74632652 | 1 | < 0.1% |
| 79.67000122 | 1 | < 0.1% |
| 79.65361609 | 1 | < 0.1% |
| 79.64263072 | 1 | < 0.1% |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| 14615_FERM0101.Temperatura_PV | 14615_FERM0101.Single_Use_pH_PV | 14615_FERM0101.Single_Use_DO_PV | 14615_FERM0101.PUMP_2_TOTAL | 14615_FERM0101.PUMP_2_PV | 14615_FERM0101.PUMP_1_TOTAL | 14615_FERM0101.PUMP_1_PV | 14615_FERM0101.pH_2_PV | 14615_FERM0101.pH_1_PV | 14615_FERM0101.Load_Cell_Net_PV | 14615_FERM0101.Gas_Overlay_PV | 14615_FERM0101.DO_2_PV | 14615_FERM0101.DO_1_PV | 14615_FERM0101.Biocontainer_Pressure_PV | 14615_FERM0101.Air_Sparge_PV | 14615_FERM0101.Agitation_PV | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DateTime | ||||||||||||||||
| 2023-03-15 00:00:00.000 | 30.239898 | 5.904 | 20.719247 | 550.186572 | 0.0 | 22.439996 | 0.0 | -0.234763 | 5.914182 | 1636.8 | 3.999874 | 0.0 | 18.732030 | 0.268969 | 0.000000 | 80.0 |
| 2023-03-15 00:15:00.000 | 29.719966 | 5.904 | 27.383203 | 550.186572 | 0.0 | 22.439996 | 0.0 | -0.234763 | 5.922070 | 1636.4 | 3.999988 | 0.0 | 25.440498 | 0.410910 | 0.000000 | 80.0 |
| 2023-03-15 00:30:00.000 | 28.871986 | 5.904 | 20.657001 | 550.186572 | 0.0 | 22.439996 | 0.0 | -0.234763 | 5.922665 | 1636.8 | 3.999654 | 0.0 | 19.010704 | 0.208331 | 0.000000 | 80.0 |
| 2023-03-15 00:45:00.000 | 28.879983 | 5.904 | 16.427148 | 550.186572 | 0.0 | 22.439996 | 0.0 | -0.234763 | 5.922080 | 1637.2 | 3.999836 | 0.0 | 14.258015 | 0.289349 | 25.697482 | 80.0 |
| 2023-03-15 01:00:00.000 | 29.424283 | 5.896 | 21.849701 | 550.186572 | 0.0 | 22.439996 | 0.0 | -0.234763 | 5.922080 | 1636.8 | 4.000337 | 0.0 | 20.125404 | 0.187840 | 0.000000 | 80.0 |
| 2023-03-15 01:15:00.000 | 30.032495 | 5.896 | 18.105228 | 550.186572 | 0.0 | 22.439996 | 0.0 | -0.234763 | 5.914186 | 1636.8 | 4.001110 | 0.0 | 14.952182 | 0.697743 | 35.093881 | 80.0 |
| 2023-03-15 01:30:00.000 | 30.224295 | 5.896 | 20.733293 | 550.186572 | 0.0 | 22.439996 | 0.0 | -0.234763 | 5.905992 | 1636.8 | 4.000109 | 0.0 | 18.868834 | 0.208331 | 0.000000 | 80.0 |
| 2023-03-15 01:45:00.000 | 30.080005 | 5.896 | 28.040974 | 550.186572 | 0.0 | 22.439996 | 0.0 | -0.234763 | 5.905991 | 1636.4 | 4.000680 | 0.0 | 25.724237 | 0.167822 | 0.000000 | 80.0 |
| 2023-03-15 02:00:00.000 | 29.856006 | 5.888 | 19.055214 | 550.186572 | 0.0 | 22.439996 | 0.0 | 0.000000 | 5.906279 | 1636.4 | 3.999676 | 0.0 | 17.191716 | 0.248228 | 0.000000 | 80.0 |
| 2023-03-15 02:15:00.000 | 29.471830 | 5.888 | 25.434689 | 550.186572 | 0.0 | 22.439996 | 0.0 | -0.234763 | 5.906279 | 1636.8 | 4.000160 | 0.0 | 23.621509 | 0.168085 | 0.000000 | 80.0 |
| 14615_FERM0101.Temperatura_PV | 14615_FERM0101.Single_Use_pH_PV | 14615_FERM0101.Single_Use_DO_PV | 14615_FERM0101.PUMP_2_TOTAL | 14615_FERM0101.PUMP_2_PV | 14615_FERM0101.PUMP_1_TOTAL | 14615_FERM0101.PUMP_1_PV | 14615_FERM0101.pH_2_PV | 14615_FERM0101.pH_1_PV | 14615_FERM0101.Load_Cell_Net_PV | 14615_FERM0101.Gas_Overlay_PV | 14615_FERM0101.DO_2_PV | 14615_FERM0101.DO_1_PV | 14615_FERM0101.Biocontainer_Pressure_PV | 14615_FERM0101.Air_Sparge_PV | 14615_FERM0101.Agitation_PV | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DateTime | ||||||||||||||||
| 2024-09-10 21:45:00.000 | 6.391998 | 799.791992 | 799.991992 | 0.0 | 0.0 | 7.92 | 0.0 | -0.264446 | 5.725302 | 1574.4 | 3.999304 | 0.0 | 0.0 | -0.176508 | 0.0 | 20.0 |
| 2024-09-10 22:00:00.000 | 6.149648 | 799.791992 | 799.991992 | 0.0 | 0.0 | 7.92 | 0.0 | -0.264446 | 5.725302 | 1574.4 | 4.000323 | 0.0 | 0.0 | -0.437413 | 0.0 | 20.0 |
| 2024-09-10 22:15:00.000 | 5.971358 | 799.791992 | 799.991992 | 0.0 | 0.0 | 7.92 | 0.0 | -0.264446 | 5.733096 | 1574.4 | 4.000620 | 0.0 | 0.0 | -0.460071 | 0.0 | 20.0 |
| 2024-09-10 22:30:00.000 | 5.767999 | 799.791992 | 799.991992 | 0.0 | 0.0 | 7.92 | 0.0 | -0.264446 | 5.733096 | 1574.4 | 4.000511 | 0.0 | 0.0 | -0.561340 | 0.0 | 20.0 |
| 2024-09-10 22:45:00.000 | 5.608002 | 799.791992 | 799.991992 | 0.0 | 0.0 | 7.92 | 0.0 | -0.264446 | 5.733096 | 1574.4 | 3.999974 | 0.0 | 0.0 | -0.460071 | 0.0 | 20.0 |
| 2024-09-10 23:00:00.000 | 5.471997 | 799.791992 | 799.991992 | 0.0 | 0.0 | 7.92 | 0.0 | -0.264446 | 5.741179 | 1574.4 | 4.000211 | 0.0 | 0.0 | -0.500580 | 0.0 | 20.0 |
| 2024-09-10 23:15:00.000 | 5.391998 | 799.791992 | 799.991992 | 0.0 | 0.0 | 7.92 | 0.0 | -0.264446 | 5.733096 | 1574.4 | 4.000082 | 0.0 | 0.0 | -0.466258 | 0.0 | 20.0 |
| 2024-09-10 23:30:00.000 | 5.359998 | 799.791992 | 799.991992 | 0.0 | 0.0 | 7.92 | 0.0 | -0.264446 | 5.725302 | 1574.8 | 4.000421 | 0.0 | 0.0 | -0.558242 | 0.0 | 20.0 |
| 2024-09-10 23:45:00.000 | 5.384003 | 799.791992 | 799.991992 | 0.0 | 0.0 | 7.92 | 0.0 | -0.264446 | 5.717219 | 1574.8 | 4.000059 | 0.0 | 0.0 | -0.533066 | 0.0 | 20.0 |
| 2024-09-11 00:00:00.000 | 5.408002 | 799.791992 | 799.991992 | 0.0 | 0.0 | 7.92 | 0.0 | -0.264446 | 5.709136 | 1574.8 | 3.999854 | 0.0 | 0.0 | -0.447984 | 0.0 | 20.0 |
Most frequently occurring
| 14615_FERM0101.Temperatura_PV | 14615_FERM0101.Single_Use_pH_PV | 14615_FERM0101.Single_Use_DO_PV | 14615_FERM0101.PUMP_2_TOTAL | 14615_FERM0101.PUMP_2_PV | 14615_FERM0101.PUMP_1_TOTAL | 14615_FERM0101.PUMP_1_PV | 14615_FERM0101.pH_2_PV | 14615_FERM0101.pH_1_PV | 14615_FERM0101.Load_Cell_Net_PV | 14615_FERM0101.Gas_Overlay_PV | 14615_FERM0101.DO_2_PV | 14615_FERM0101.DO_1_PV | 14615_FERM0101.Biocontainer_Pressure_PV | 14615_FERM0101.Air_Sparge_PV | 14615_FERM0101.Agitation_PV | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1103 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4352 |
| 658 | 17.671997 | 800.056006 | 695.101221 | 7987.819531 | 0.0 | 17.159998 | 0.0 | -0.234763 | 1.497357 | -19.2 | 0.0 | 0.0 | 0.0 | 480.0 | 0.0 | 0.0 | 224 |
| 133 | 14.831995 | 799.791992 | 659.732813 | 9120.979687 | 0.0 | 40.479999 | 0.0 | -0.264446 | 1.416254 | -18.0 | 0.0 | 0.0 | 0.0 | 480.0 | 0.0 | 0.0 | 23 |
| 125 | 14.783997 | 799.791992 | 659.732813 | 9120.979687 | 0.0 | 40.479999 | 0.0 | -0.264446 | 1.416254 | -18.0 | 0.0 | 0.0 | 0.0 | 480.0 | 0.0 | 0.0 | 22 |
| 107 | 14.656006 | 799.791992 | 659.732813 | 9120.979687 | 0.0 | 40.479999 | 0.0 | -0.264446 | 1.416254 | -18.0 | 0.0 | 0.0 | 0.0 | 480.0 | 0.0 | 0.0 | 19 |
| 110 | 14.695996 | 799.791992 | 659.732813 | 9120.979687 | 0.0 | 40.479999 | 0.0 | -0.264446 | 1.416254 | -18.0 | 0.0 | 0.0 | 0.0 | 480.0 | 0.0 | 0.0 | 19 |
| 113 | 14.704004 | 799.791992 | 659.732813 | 9120.979687 | 0.0 | 40.479999 | 0.0 | -0.264446 | 1.416254 | -18.0 | 0.0 | 0.0 | 0.0 | 480.0 | 0.0 | 0.0 | 18 |
| 115 | 14.728003 | 799.791992 | 659.732813 | 9120.979687 | 0.0 | 40.479999 | 0.0 | -0.264446 | 1.416254 | -18.0 | 0.0 | 0.0 | 0.0 | 480.0 | 0.0 | 0.0 | 17 |
| 875 | 24.247998 | 799.791992 | 659.732813 | 9120.979687 | 0.0 | 40.479999 | 0.0 | 1.564368 | 1.300273 | -18.8 | 0.0 | 0.0 | 0.0 | 480.0 | 0.0 | 0.0 | 17 |
| 1082 | 26.480005 | 799.791992 | 659.732813 | 9120.979687 | 0.0 | 40.479999 | 0.0 | 1.564368 | 1.300273 | -18.8 | 0.0 | 0.0 | 0.0 | 480.0 | 0.0 | 0.0 | 16 |